export const GETNUM = {
  usernum:'SELECT COUNT(ID) usernum FROM SRC_USER',
  ctnum:'SELECT COUNT(ID) ctnum FROM SRC_CPTTS',
  hisctnum:'SELECT COUNT(ID) hisctnum FROM SRC_HISEVENTS',
  // user:'SELECT COUNT(ID) user_num FROM SRC_USER',
  // user:'SELECT COUNT(ID) user_num FROM SRC_USER',
  // user:'SELECT COUNT(ID) user_num FROM SRC_USER',
  // user:'SELECT COUNT(ID) user_num FROM SRC_USER',
  // user:'SELECT COUNT(ID) user_num FROM SRC_USER',
  // user:'SELECT COUNT(ID) user_num FROM SRC_USER',
  // user:'SELECT COUNT(ID) user_num FROM SRC_USER',
}

export const GROUPBY = {
  TYPE:`
    SELECT TYPE,COUNT(TYPE) NUM 
    FROM SRC_USER 
    GROUP BY TYPE`,
  SEX:`
    SELECT TYPE,COUNT(TYPE) NUM 
    FROM SRC_USER 
    GROUP BY TYPE`,
}

